To Define a Non-Graphical Sub-Feature
-
Create the table with no geometry column, one ID, and one foreign key.
CREATE TABLE NOGRAPHIC
(Id NUMBER PRIMARY KEY,
LinkedID NUMBER,
NAME VARCHAR2(50));
-
Create the foreign key constraint defining the non-graphical sub-feature.
alter table NOGRAPHIC
add constraint NOGRAPHICCABLE_FK
foreign key(LINKEDID)
references CABLE(ID)
ON DELETE CASCADE;